package test.iface;

import test.model.User;

import cn.javadoc.db.Val;
// 输入参数     动态SQL   占位符
// 数组                      $        ?  
// 对象           #属性名#   $属性名$

public interface ISqlUser {

	@Val("select count(*) from TUSERINFO where userno=?")
	public int getCountUser(String userno);

	@Val("select * from TUSERINFO  where userno=?")
	public User getUserByUserno(String userno);

	@Val("select * from TUSERINFO  where userno=$")
	public User getUserByUsernoDy(String userno);

	// @Val("update User set password=#password# where username=#username#")
	// public void updateUser(User user);
	//
	// @Val("select * from User where username=?")
	// public Map<String, String> getUser(String username);
	//
	// @Val("select * from User where username=?")
	// public List<Map<String, String>> getUserMapList(String username);
	//
	// @Val("select * from User where username=?")
	// public List<User> getUserObjectList(String username);
}
